Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 115520 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 19.4 MiB |
| Average record size in memory | 176.0 B |
Variable types
| Text | 8 |
|---|---|
| Categorical | 4 |
| DateTime | 1 |
| Numeric | 8 |
customer_state is highly overall correlated with customer_zip_code_prefix | High correlation |
customer_zip_code_prefix is highly overall correlated with customer_state | High correlation |
payment_value is highly overall correlated with price | High correlation |
price is highly overall correlated with payment_value | High correlation |
seller_state is highly overall correlated with seller_zip_code_prefix | High correlation |
seller_zip_code_prefix is highly overall correlated with seller_state | High correlation |
order_status is highly imbalanced (92.8%) | Imbalance |
seller_state is highly imbalanced (62.7%) | Imbalance |
Reproduction
| Analysis started | 2024-10-16 14:06:43.723611 |
|---|---|
| Analysis finished | 2024-10-16 14:06:57.091553 |
| Duration | 13.37 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
order_id
Text
| Distinct | 96967 |
|---|---|
| Distinct (%) | 83.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3696640 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 84736 ? |
|---|---|
| Unique (%) | 73.4% |
Sample
| 1st row | e481f51cbdc54678b7cc49136f2d6af7 |
|---|---|
| 2nd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 3rd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 4th row | 128e10d95713541c87cd1a2e48201934 |
| 5th row | 0e7e841ddf8f8f2de2bad69267ecfbcf |
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| 285c2e15bebd4ac83635ccc563dc71f4 | 22 | < 0.1% |
| 1c11d0f4353b31ac3417fbfa5f0f2a8a | 21 | < 0.1% |
| Other values (96957) | 115225 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 232173 | 6.3% |
| b | 232045 | 6.3% |
| 6 | 231977 | 6.3% |
| e | 231746 | 6.3% |
| 3 | 231264 | 6.3% |
| c | 231256 | 6.3% |
| 7 | 231168 | 6.3% |
| 8 | 231132 | 6.3% |
| 1 | 231097 | 6.3% |
| a | 230987 | 6.2% |
| Other values (6) | 1381795 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 232173 | 6.3% |
| b | 232045 | 6.3% |
| 6 | 231977 | 6.3% |
| e | 231746 | 6.3% |
| 3 | 231264 | 6.3% |
| c | 231256 | 6.3% |
| 7 | 231168 | 6.3% |
| 8 | 231132 | 6.3% |
| 1 | 231097 | 6.3% |
| a | 230987 | 6.2% |
| Other values (6) | 1381795 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 232173 | 6.3% |
| b | 232045 | 6.3% |
| 6 | 231977 | 6.3% |
| e | 231746 | 6.3% |
| 3 | 231264 | 6.3% |
| c | 231256 | 6.3% |
| 7 | 231168 | 6.3% |
| 8 | 231132 | 6.3% |
| 1 | 231097 | 6.3% |
| a | 230987 | 6.2% |
| Other values (6) | 1381795 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 232173 | 6.3% |
| b | 232045 | 6.3% |
| 6 | 231977 | 6.3% |
| e | 231746 | 6.3% |
| 3 | 231264 | 6.3% |
| c | 231256 | 6.3% |
| 7 | 231168 | 6.3% |
| 8 | 231132 | 6.3% |
| 1 | 231097 | 6.3% |
| a | 230987 | 6.2% |
| Other values (6) | 1381795 |
customer_id
Text
| Distinct | 96967 |
|---|---|
| Distinct (%) | 83.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3696640 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 84736 ? |
|---|---|
| Unique (%) | 73.4% |
Sample
| 1st row | 9ef432eb6251297304e76186b10a928d |
|---|---|
| 2nd row | 9ef432eb6251297304e76186b10a928d |
| 3rd row | 9ef432eb6251297304e76186b10a928d |
| 4th row | a20e8105f23924cd00833fd87daa0831 |
| 5th row | 26c7ac168e1433912a51b924fbd34d34 |
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| b246eeed30b362c09d867b9e598bee51 | 22 | < 0.1% |
| 50920f8cd0681fd86ebe93670c8fe52e | 21 | < 0.1% |
| Other values (96957) | 115225 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 231689 | 6.3% |
| f | 231598 | 6.3% |
| 5 | 231557 | 6.3% |
| c | 231500 | 6.3% |
| 6 | 231348 | 6.3% |
| 1 | 231308 | 6.3% |
| 8 | 231128 | 6.3% |
| a | 231051 | 6.3% |
| 3 | 230987 | 6.2% |
| 7 | 230945 | 6.2% |
| Other values (6) | 1383529 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 231689 | 6.3% |
| f | 231598 | 6.3% |
| 5 | 231557 | 6.3% |
| c | 231500 | 6.3% |
| 6 | 231348 | 6.3% |
| 1 | 231308 | 6.3% |
| 8 | 231128 | 6.3% |
| a | 231051 | 6.3% |
| 3 | 230987 | 6.2% |
| 7 | 230945 | 6.2% |
| Other values (6) | 1383529 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 231689 | 6.3% |
| f | 231598 | 6.3% |
| 5 | 231557 | 6.3% |
| c | 231500 | 6.3% |
| 6 | 231348 | 6.3% |
| 1 | 231308 | 6.3% |
| 8 | 231128 | 6.3% |
| a | 231051 | 6.3% |
| 3 | 230987 | 6.2% |
| 7 | 230945 | 6.2% |
| Other values (6) | 1383529 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 231689 | 6.3% |
| f | 231598 | 6.3% |
| 5 | 231557 | 6.3% |
| c | 231500 | 6.3% |
| 6 | 231348 | 6.3% |
| 1 | 231308 | 6.3% |
| 8 | 231128 | 6.3% |
| a | 231051 | 6.3% |
| 3 | 230987 | 6.2% |
| 7 | 230945 | 6.2% |
| Other values (6) | 1383529 |
order_status
Categorical
IMBALANCE
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| delivered | |
|---|---|
| shipped | 1203 |
| canceled | 536 |
| processing | 360 |
| invoiced | 340 |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.9746797 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1036755 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 113078 | |
| shipped | 1203 | 1.0% |
| canceled | 536 | 0.5% |
| processing | 360 | 0.3% |
| invoiced | 340 | 0.3% |
| approved | 3 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 113078 | |
| shipped | 1203 | 1.0% |
| canceled | 536 | 0.5% |
| processing | 360 | 0.3% |
| invoiced | 340 | 0.3% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 342212 | |
| d | 228238 | |
| i | 115321 | 11.1% |
| l | 113614 | 11.0% |
| r | 113441 | 10.9% |
| v | 113421 | 10.9% |
| p | 2772 | 0.3% |
| s | 1923 | 0.2% |
| c | 1772 | 0.2% |
| n | 1236 | 0.1% |
| Other values (4) | 2805 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1036755 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 342212 | |
| d | 228238 | |
| i | 115321 | 11.1% |
| l | 113614 | 11.0% |
| r | 113441 | 10.9% |
| v | 113421 | 10.9% |
| p | 2772 | 0.3% |
| s | 1923 | 0.2% |
| c | 1772 | 0.2% |
| n | 1236 | 0.1% |
| Other values (4) | 2805 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1036755 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 342212 | |
| d | 228238 | |
| i | 115321 | 11.1% |
| l | 113614 | 11.0% |
| r | 113441 | 10.9% |
| v | 113421 | 10.9% |
| p | 2772 | 0.3% |
| s | 1923 | 0.2% |
| c | 1772 | 0.2% |
| n | 1236 | 0.1% |
| Other values (4) | 2805 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1036755 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 342212 | |
| d | 228238 | |
| i | 115321 | 11.1% |
| l | 113614 | 11.0% |
| r | 113441 | 10.9% |
| v | 113421 | 10.9% |
| p | 2772 | 0.3% |
| s | 1923 | 0.2% |
| c | 1772 | 0.2% |
| n | 1236 | 0.1% |
| Other values (4) | 2805 | 0.3% |
| Distinct | 96432 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2017-01-05 11:56:06 |
|---|---|
| Maximum | 2018-09-03 09:06:57 |
Histogram with fixed size bins (bins=50)
order_item_id
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1961305 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.69939972 |
|---|---|
| Coefficient of variation (CV) | 0.58471855 |
| Kurtosis | 104.79589 |
| Mean | 1.1961305 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.600338 |
| Sum | 138177 |
| Variance | 0.48915997 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 1 | 101228 | |
| 2 | 10059 | 8.7% |
| 3 | 2333 | 2.0% |
| 4 | 969 | 0.8% |
| 5 | 459 | 0.4% |
| 6 | 258 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 66 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 101228 | |
| 2 | 10059 | 8.7% |
| 3 | 2333 | 2.0% |
| 4 | 969 | 0.8% |
| 5 | 459 | 0.4% |
| 6 | 258 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 7 | |
| 13 | 8 | |
| 12 | 13 |
product_id
Text
| Distinct | 32177 |
|---|---|
| Distinct (%) | 27.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3696640 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 16995 ? |
|---|---|
| Unique (%) | 14.7% |
Sample
| 1st row | 87285b34884572647811a353c7ac498a |
|---|---|
| 2nd row | 87285b34884572647811a353c7ac498a |
| 3rd row | 87285b34884572647811a353c7ac498a |
| 4th row | 87285b34884572647811a353c7ac498a |
| 5th row | 87285b34884572647811a353c7ac498a |
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 536 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 525 | 0.5% |
| 422879e10f46682990de24d770e7f83d | 505 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 406 | 0.4% |
| 368c6c730842d78016ad823897a372db | 395 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 389 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 357 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 327 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 283 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 278 | 0.2% |
| Other values (32167) | 111519 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 237738 | 6.4% |
| 9 | 235906 | 6.4% |
| e | 233463 | 6.3% |
| 7 | 232907 | 6.3% |
| 8 | 232402 | 6.3% |
| 4 | 231211 | 6.3% |
| a | 231088 | 6.3% |
| 2 | 230852 | 6.2% |
| c | 230814 | 6.2% |
| 0 | 230643 | 6.2% |
| Other values (6) | 1369616 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 237738 | 6.4% |
| 9 | 235906 | 6.4% |
| e | 233463 | 6.3% |
| 7 | 232907 | 6.3% |
| 8 | 232402 | 6.3% |
| 4 | 231211 | 6.3% |
| a | 231088 | 6.3% |
| 2 | 230852 | 6.2% |
| c | 230814 | 6.2% |
| 0 | 230643 | 6.2% |
| Other values (6) | 1369616 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 237738 | 6.4% |
| 9 | 235906 | 6.4% |
| e | 233463 | 6.3% |
| 7 | 232907 | 6.3% |
| 8 | 232402 | 6.3% |
| 4 | 231211 | 6.3% |
| a | 231088 | 6.3% |
| 2 | 230852 | 6.2% |
| c | 230814 | 6.2% |
| 0 | 230643 | 6.2% |
| Other values (6) | 1369616 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 237738 | 6.4% |
| 9 | 235906 | 6.4% |
| e | 233463 | 6.3% |
| 7 | 232907 | 6.3% |
| 8 | 232402 | 6.3% |
| 4 | 231211 | 6.3% |
| a | 231088 | 6.3% |
| 2 | 230852 | 6.2% |
| c | 230814 | 6.2% |
| 0 | 230643 | 6.2% |
| Other values (6) | 1369616 |
seller_id
Text
| Distinct | 3007 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3696640 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 473 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
|---|---|
| 2nd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 3rd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 4th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 5th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2133 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2122 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2008 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1847 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1639 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1528 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1462 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1452 | 1.3% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1240 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1239 | 1.1% |
| Other values (2997) | 98850 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 251809 | 6.8% |
| c | 243363 | 6.6% |
| 4 | 243019 | 6.6% |
| 6 | 238051 | 6.4% |
| 0 | 237041 | 6.4% |
| a | 236536 | 6.4% |
| b | 235438 | 6.4% |
| 3 | 235225 | 6.4% |
| 9 | 228750 | 6.2% |
| 2 | 227554 | 6.2% |
| Other values (6) | 1319854 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 251809 | 6.8% |
| c | 243363 | 6.6% |
| 4 | 243019 | 6.6% |
| 6 | 238051 | 6.4% |
| 0 | 237041 | 6.4% |
| a | 236536 | 6.4% |
| b | 235438 | 6.4% |
| 3 | 235225 | 6.4% |
| 9 | 228750 | 6.2% |
| 2 | 227554 | 6.2% |
| Other values (6) | 1319854 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 251809 | 6.8% |
| c | 243363 | 6.6% |
| 4 | 243019 | 6.6% |
| 6 | 238051 | 6.4% |
| 0 | 237041 | 6.4% |
| a | 236536 | 6.4% |
| b | 235438 | 6.4% |
| 3 | 235225 | 6.4% |
| 9 | 228750 | 6.2% |
| 2 | 227554 | 6.2% |
| Other values (6) | 1319854 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 251809 | 6.8% |
| c | 243363 | 6.6% |
| 4 | 243019 | 6.6% |
| 6 | 238051 | 6.4% |
| 0 | 237041 | 6.4% |
| a | 236536 | 6.4% |
| b | 235438 | 6.4% |
| 3 | 235225 | 6.4% |
| 9 | 228750 | 6.2% |
| 2 | 227554 | 6.2% |
| Other values (6) | 1319854 |
price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 5897 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.90668 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 184.28063 |
|---|---|
| Coefficient of variation (CV) | 1.524156 |
| Kurtosis | 118.82035 |
| Mean | 120.90668 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.8622591 |
| Sum | 13967139 |
| Variance | 33959.351 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 59.9 | 2558 | 2.2% |
| 69.9 | 2079 | 1.8% |
| 49.9 | 2009 | 1.7% |
| 89.9 | 1599 | 1.4% |
| 99.9 | 1490 | 1.3% |
| 29.9 | 1356 | 1.2% |
| 39.9 | 1327 | 1.1% |
| 19.9 | 1268 | 1.1% |
| 79.9 | 1261 | 1.1% |
| 29.99 | 1209 | 1.0% |
| Other values (5887) | 99364 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| 3.54 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6729 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 |
freight_value
Real number (ℝ)
| Distinct | 6966 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.075696 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 388 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.32 |
| Q3 | 21.22 |
| 95-th percentile | 45.4 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.14 |
Descriptive statistics
| Standard deviation | 15.87439 |
|---|---|
| Coefficient of variation (CV) | 0.79072673 |
| Kurtosis | 57.929779 |
| Mean | 20.075696 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.5501683 |
| Sum | 2319144.4 |
| Variance | 251.99625 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15.1 | 3758 | 3.3% |
| 7.78 | 2289 | 2.0% |
| 14.1 | 1933 | 1.7% |
| 11.85 | 1933 | 1.7% |
| 18.23 | 1602 | 1.4% |
| 7.39 | 1554 | 1.3% |
| 16.11 | 1178 | 1.0% |
| 15.23 | 1047 | 0.9% |
| 8.72 | 943 | 0.8% |
| 16.79 | 906 | 0.8% |
| Other values (6956) | 98377 |
| Value | Count | Frequency (%) |
| 0 | 388 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 3 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
payment_sequential
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0928238 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.72581133 |
|---|---|
| Coefficient of variation (CV) | 0.66416138 |
| Kurtosis | 357.32827 |
| Mean | 1.0928238 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.16416 |
| Sum | 126243 |
| Variance | 0.52680209 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 1 | 110593 | |
| 2 | 3302 | 2.9% |
| 3 | 631 | 0.5% |
| 4 | 303 | 0.3% |
| 5 | 180 | 0.2% |
| 6 | 124 | 0.1% |
| 7 | 85 | 0.1% |
| 8 | 56 | < 0.1% |
| 9 | 46 | < 0.1% |
| 10 | 39 | < 0.1% |
| Other values (19) | 161 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 110593 | |
| 2 | 3302 | 2.9% |
| 3 | 631 | 0.5% |
| 4 | 303 | 0.3% |
| 5 | 180 | 0.2% |
| 6 | 124 | 0.1% |
| 7 | 85 | 0.1% |
| 8 | 56 | < 0.1% |
| 9 | 46 | < 0.1% |
| 10 | 39 | < 0.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 22 | 3 | |
| 21 | 6 | |
| 20 | 6 |
payment_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| credit_card | |
|---|---|
| boleto | |
| voucher | 6134 |
| debit_card | 1661 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.800277 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1132128 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | voucher |
| 3rd row | voucher |
| 4th row | credit_card |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 85246 | |
| boleto | 22479 | 19.5% |
| voucher | 6134 | 5.3% |
| debit_card | 1661 | 1.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit_card | 85246 | |
| boleto | 22479 | 19.5% |
| voucher | 6134 | 5.3% |
| debit_card | 1661 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 178287 | |
| r | 178287 | |
| d | 173814 | |
| e | 115520 | |
| t | 109386 | |
| i | 86907 | |
| _ | 86907 | |
| a | 86907 | |
| o | 51092 | 4.5% |
| b | 24140 | 2.1% |
| Other values (4) | 40881 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1132128 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| c | 178287 | |
| r | 178287 | |
| d | 173814 | |
| e | 115520 | |
| t | 109386 | |
| i | 86907 | |
| _ | 86907 | |
| a | 86907 | |
| o | 51092 | 4.5% |
| b | 24140 | 2.1% |
| Other values (4) | 40881 | 3.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1132128 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| c | 178287 | |
| r | 178287 | |
| d | 173814 | |
| e | 115520 | |
| t | 109386 | |
| i | 86907 | |
| _ | 86907 | |
| a | 86907 | |
| o | 51092 | 4.5% |
| b | 24140 | 2.1% |
| Other values (4) | 40881 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1132128 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| c | 178287 | |
| r | 178287 | |
| d | 173814 | |
| e | 115520 | |
| t | 109386 | |
| i | 86907 | |
| _ | 86907 | |
| a | 86907 | |
| o | 51092 | 4.5% |
| b | 24140 | 2.1% |
| Other values (4) | 40881 | 3.6% |
payment_installments
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9427285 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.7780283 |
|---|---|
| Coefficient of variation (CV) | 0.94403145 |
| Kurtosis | 2.5320115 |
| Mean | 2.9427285 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.6216668 |
| Sum | 339944 |
| Variance | 7.7174412 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 1 | 57573 | |
| 2 | 13437 | 11.6% |
| 3 | 11535 | 10.0% |
| 4 | 7854 | 6.8% |
| 10 | 6735 | 5.8% |
| 5 | 5918 | 5.1% |
| 8 | 5007 | 4.3% |
| 6 | 4534 | 3.9% |
| 7 | 1779 | 1.5% |
| 9 | 717 | 0.6% |
| Other values (14) | 431 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 57573 | |
| 2 | 13437 | 11.6% |
| 3 | 11535 | 10.0% |
| 4 | 7854 | 6.8% |
| 5 | 5918 | 5.1% |
| 6 | 4534 | 3.9% |
| 7 | 1779 | 1.5% |
| 8 | 5007 | 4.3% |
| 9 | 717 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 5 | < 0.1% |
| 20 | 21 | < 0.1% |
| 18 | 38 | |
| 17 | 7 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 92 | |
| 14 | 16 | < 0.1% |
payment_value
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28685 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.96699 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.29 |
| Q1 | 61.01 |
| median | 108.2 |
| Q3 | 189.5925 |
| 95-th percentile | 516.2515 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.5825 |
Descriptive statistics
| Standard deviation | 268.30463 |
|---|---|
| Coefficient of variation (CV) | 1.5511897 |
| Kurtosis | 510.5349 |
| Mean | 172.96699 |
| Median Absolute Deviation (MAD) | 56.7 |
| Skewness | 14.15703 |
| Sum | 19981147 |
| Variance | 71987.372 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50 | 339 | 0.3% |
| 100 | 296 | 0.3% |
| 20 | 281 | 0.2% |
| 77.57 | 249 | 0.2% |
| 35 | 163 | 0.1% |
| 73.34 | 158 | 0.1% |
| 30 | 134 | 0.1% |
| 116.94 | 130 | 0.1% |
| 56.78 | 122 | 0.1% |
| 25 | 117 | 0.1% |
| Other values (28675) | 113531 |
| Value | Count | Frequency (%) |
| 0 | 6 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | |
| 0.11 | 2 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.14 | 5 |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6922.21 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 45 |
|---|---|
| Median length | 33 |
| Mean length | 12.98608 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1500152 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | housewares |
|---|---|
| 2nd row | housewares |
| 3rd row | housewares |
| 4th row | housewares |
| 5th row | housewares |
| Value | Count | Frequency (%) |
| bed_bath_table | 11815 | 10.2% |
| health_beauty | 9922 | 8.6% |
| sports_leisure | 8926 | 7.7% |
| furniture_decor | 8667 | 7.5% |
| computers_accessories | 8058 | 7.0% |
| housewares | 7343 | 6.4% |
| watches_gifts | 6196 | 5.4% |
| telephony | 4710 | 4.1% |
| garden_tools | 4569 | 4.0% |
| auto | 4367 | 3.8% |
| Other values (63) | 40947 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 183479 | |
| s | 140998 | 9.4% |
| t | 132194 | 8.8% |
| o | 111040 | 7.4% |
| r | 104702 | 7.0% |
| a | 101494 | 6.8% |
| _ | 101213 | 6.7% |
| u | 77390 | 5.2% |
| c | 71817 | 4.8% |
| i | 62761 | 4.2% |
| Other values (16) | 413064 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1500152 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 183479 | |
| s | 140998 | 9.4% |
| t | 132194 | 8.8% |
| o | 111040 | 7.4% |
| r | 104702 | 7.0% |
| a | 101494 | 6.8% |
| _ | 101213 | 6.7% |
| u | 77390 | 5.2% |
| c | 71817 | 4.8% |
| i | 62761 | 4.2% |
| Other values (16) | 413064 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1500152 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 183479 | |
| s | 140998 | 9.4% |
| t | 132194 | 8.8% |
| o | 111040 | 7.4% |
| r | 104702 | 7.0% |
| a | 101494 | 6.8% |
| _ | 101213 | 6.7% |
| u | 77390 | 5.2% |
| c | 71817 | 4.8% |
| i | 62761 | 4.2% |
| Other values (16) | 413064 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1500152 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 183479 | |
| s | 140998 | 9.4% |
| t | 132194 | 8.8% |
| o | 111040 | 7.4% |
| r | 104702 | 7.0% |
| a | 101494 | 6.8% |
| _ | 101213 | 6.7% |
| u | 77390 | 5.2% |
| c | 71817 | 4.8% |
| i | 62761 | 4.2% |
| Other values (16) | 413064 |
| Distinct | 93811 |
|---|---|
| Distinct (%) | 81.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3696640 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 79760 ? |
|---|---|
| Unique (%) | 69.0% |
Sample
| 1st row | 7c396fd4830fd04220f754e42b4e5bff |
|---|---|
| 2nd row | 7c396fd4830fd04220f754e42b4e5bff |
| 3rd row | 7c396fd4830fd04220f754e42b4e5bff |
| 4th row | 3a51803cc0d012c3b5dc8b7528cb05f7 |
| 5th row | ef0996a1a279c26e7ecbd737be23d235 |
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| 5419a7c9b86a43d8140e2939cd2c2f7e | 24 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| db1af3fd6b23ac3873ef02619d548f9c | 24 | < 0.1% |
| 2524dcec233c3766f2c2b22f69fd65f4 | 22 | < 0.1% |
| Other values (93801) | 115199 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 232052 | 6.3% |
| 1 | 231648 | 6.3% |
| b | 231626 | 6.3% |
| a | 231329 | 6.3% |
| 3 | 231258 | 6.3% |
| d | 231253 | 6.3% |
| 8 | 231099 | 6.3% |
| e | 230978 | 6.2% |
| 9 | 230972 | 6.2% |
| 2 | 230959 | 6.2% |
| Other values (6) | 1383466 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6 | 232052 | 6.3% |
| 1 | 231648 | 6.3% |
| b | 231626 | 6.3% |
| a | 231329 | 6.3% |
| 3 | 231258 | 6.3% |
| d | 231253 | 6.3% |
| 8 | 231099 | 6.3% |
| e | 230978 | 6.2% |
| 9 | 230972 | 6.2% |
| 2 | 230959 | 6.2% |
| Other values (6) | 1383466 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6 | 232052 | 6.3% |
| 1 | 231648 | 6.3% |
| b | 231626 | 6.3% |
| a | 231329 | 6.3% |
| 3 | 231258 | 6.3% |
| d | 231253 | 6.3% |
| 8 | 231099 | 6.3% |
| e | 230978 | 6.2% |
| 9 | 230972 | 6.2% |
| 2 | 230959 | 6.2% |
| Other values (6) | 1383466 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3696640 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6 | 232052 | 6.3% |
| 1 | 231648 | 6.3% |
| b | 231626 | 6.3% |
| a | 231329 | 6.3% |
| 3 | 231258 | 6.3% |
| d | 231253 | 6.3% |
| 8 | 231099 | 6.3% |
| e | 230978 | 6.2% |
| 9 | 230972 | 6.2% |
| 2 | 230959 | 6.2% |
| Other values (6) | 1383466 |
customer_zip_code_prefix
Real number (ℝ)
HIGH CORRELATION
| Distinct | 14923 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35035.811 |
| Minimum | 1003 |
|---|---|
| Maximum | 99980 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3286 |
| Q1 | 11310 |
| median | 24315 |
| Q3 | 58428 |
| 95-th percentile | 90560 |
| Maximum | 99980 |
| Range | 98977 |
| Interquartile range (IQR) | 47118 |
Descriptive statistics
| Standard deviation | 29808.18 |
|---|---|
| Coefficient of variation (CV) | 0.85079177 |
| Kurtosis | -0.7798954 |
| Mean | 35035.811 |
| Median Absolute Deviation (MAD) | 16294 |
| Skewness | 0.7855617 |
| Sum | 4.0473369 × 109 |
| Variance | 8.8852759 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 24220 | 154 | 0.1% |
| 22790 | 153 | 0.1% |
| 22793 | 151 | 0.1% |
| 24230 | 134 | 0.1% |
| 22775 | 125 | 0.1% |
| 35162 | 122 | 0.1% |
| 29101 | 119 | 0.1% |
| 11740 | 110 | 0.1% |
| 13087 | 106 | 0.1% |
| 36570 | 104 | 0.1% |
| Other values (14913) | 114242 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 4 | |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 2 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 8 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
| 99920 | 1 | < 0.1% |
customer_city
Text
| Distinct | 4092 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.332185 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1193574 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1032 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | sao paulo |
|---|---|
| 2nd row | sao paulo |
| 3rd row | sao paulo |
| 4th row | sao paulo |
| 5th row | sao paulo |
| Value | Count | Frequency (%) |
| sao | 24589 | 12.1% |
| paulo | 18318 | 9.0% |
| de | 11259 | 5.6% |
| rio | 9636 | 4.8% |
| janeiro | 8020 | 4.0% |
| do | 4964 | 2.5% |
| belo | 3249 | 1.6% |
| horizonte | 3205 | 1.6% |
| brasilia | 2427 | 1.2% |
| porto | 1933 | 1.0% |
| Other values (3266) | 114881 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 196998 | |
| o | 147185 | |
| i | 91289 | 7.6% |
| r | 88470 | 7.4% |
| 86961 | 7.3% | |
| e | 77451 | 6.5% |
| s | 73129 | 6.1% |
| n | 52865 | 4.4% |
| u | 52421 | 4.4% |
| l | 52003 | 4.4% |
| Other values (21) | 274802 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1193574 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 196998 | |
| o | 147185 | |
| i | 91289 | 7.6% |
| r | 88470 | 7.4% |
| 86961 | 7.3% | |
| e | 77451 | 6.5% |
| s | 73129 | 6.1% |
| n | 52865 | 4.4% |
| u | 52421 | 4.4% |
| l | 52003 | 4.4% |
| Other values (21) | 274802 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1193574 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 196998 | |
| o | 147185 | |
| i | 91289 | 7.6% |
| r | 88470 | 7.4% |
| 86961 | 7.3% | |
| e | 77451 | 6.5% |
| s | 73129 | 6.1% |
| n | 52865 | 4.4% |
| u | 52421 | 4.4% |
| l | 52003 | 4.4% |
| Other values (21) | 274802 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1193574 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 196998 | |
| o | 147185 | |
| i | 91289 | 7.6% |
| r | 88470 | 7.4% |
| 86961 | 7.3% | |
| e | 77451 | 6.5% |
| s | 73129 | 6.1% |
| n | 52865 | 4.4% |
| u | 52421 | 4.4% |
| l | 52003 | 4.4% |
| Other values (21) | 274802 |
customer_state
Categorical
HIGH CORRELATION
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 231040 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 48724 | |
| RJ | 15029 | 13.0% |
| MG | 13406 | 11.6% |
| RS | 6359 | 5.5% |
| PR | 5850 | 5.1% |
| SC | 4223 | 3.7% |
| BA | 3971 | 3.4% |
| DF | 2432 | 2.1% |
| GO | 2367 | 2.0% |
| ES | 2315 | 2.0% |
| Other values (17) | 10844 | 9.4% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| sp | 48724 | |
| rj | 15029 | 13.0% |
| mg | 13406 | 11.6% |
| rs | 6359 | 5.5% |
| pr | 5850 | 5.1% |
| sc | 4223 | 3.7% |
| ba | 3971 | 3.4% |
| df | 2432 | 2.1% |
| go | 2367 | 2.0% |
| es | 2315 | 2.0% |
| Other values (17) | 10844 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 62847 | |
| P | 58799 | |
| R | 28170 | |
| M | 16343 | 7.1% |
| G | 15773 | 6.8% |
| J | 15029 | 6.5% |
| A | 6683 | 2.9% |
| E | 6091 | 2.6% |
| C | 5842 | 2.5% |
| B | 4599 | 2.0% |
| Other values (7) | 10864 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 231040 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 62847 | |
| P | 58799 | |
| R | 28170 | |
| M | 16343 | 7.1% |
| G | 15773 | 6.8% |
| J | 15029 | 6.5% |
| A | 6683 | 2.9% |
| E | 6091 | 2.6% |
| C | 5842 | 2.5% |
| B | 4599 | 2.0% |
| Other values (7) | 10864 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 231040 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 62847 | |
| P | 58799 | |
| R | 28170 | |
| M | 16343 | 7.1% |
| G | 15773 | 6.8% |
| J | 15029 | 6.5% |
| A | 6683 | 2.9% |
| E | 6091 | 2.6% |
| C | 5842 | 2.5% |
| B | 4599 | 2.0% |
| Other values (7) | 10864 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 231040 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 62847 | |
| P | 58799 | |
| R | 28170 | |
| M | 16343 | 7.1% |
| G | 15773 | 6.8% |
| J | 15029 | 6.5% |
| A | 6683 | 2.9% |
| E | 6091 | 2.6% |
| C | 5842 | 2.5% |
| B | 4599 | 2.0% |
| Other values (7) | 10864 | 4.7% |
seller_zip_code_prefix
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2198 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24480.427 |
| Minimum | 1001 |
|---|---|
| Maximum | 99730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 2963 |
| Q1 | 6429 |
| median | 13660 |
| Q3 | 28470 |
| 95-th percentile | 88330 |
| Maximum | 99730 |
| Range | 98729 |
| Interquartile range (IQR) | 22041 |
Descriptive statistics
| Standard deviation | 27613.774 |
|---|---|
| Coefficient of variation (CV) | 1.127994 |
| Kurtosis | 0.91808654 |
| Mean | 24480.427 |
| Median Absolute Deviation (MAD) | 8130 |
| Skewness | 1.5511073 |
| Sum | 2.8279789 × 109 |
| Variance | 7.6252052 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 14940 | 8170 | 7.1% |
| 5849 | 2137 | 1.8% |
| 15025 | 2089 | 1.8% |
| 9015 | 1853 | 1.6% |
| 13405 | 1650 | 1.4% |
| 4782 | 1545 | 1.3% |
| 8577 | 1538 | 1.3% |
| 3204 | 1462 | 1.3% |
| 4160 | 1267 | 1.1% |
| 13232 | 1254 | 1.1% |
| Other values (2188) | 92555 |
| Value | Count | Frequency (%) |
| 1001 | 22 | < 0.1% |
| 1021 | 41 | < 0.1% |
| 1022 | 5 | < 0.1% |
| 1023 | 5 | < 0.1% |
| 1026 | 305 | |
| 1031 | 122 | 0.1% |
| 1035 | 18 | < 0.1% |
| 1039 | 1 | < 0.1% |
| 1040 | 20 | < 0.1% |
| 1041 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99730 | 12 | < 0.1% |
| 99700 | 2 | < 0.1% |
| 99670 | 1 | < 0.1% |
| 99500 | 59 | |
| 99300 | 2 | < 0.1% |
| 98975 | 19 | < 0.1% |
| 98920 | 2 | < 0.1% |
| 98910 | 13 | < 0.1% |
| 98803 | 62 | |
| 98780 | 4 | < 0.1% |
seller_city
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 31 |
| Mean length | 10.103385 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1167143 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 64 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | maua |
|---|---|
| 2nd row | maua |
| 3rd row | maua |
| 4th row | maua |
| 5th row | maua |
| Value | Count | Frequency (%) |
| sao | 35839 | 18.0% |
| paulo | 29132 | 14.7% |
| ibitinga | 8170 | 4.1% |
| rio | 5808 | 2.9% |
| do | 5433 | 2.7% |
| preto | 5423 | 2.7% |
| jose | 4042 | 2.0% |
| de | 4004 | 2.0% |
| santo | 3206 | 1.6% |
| andre | 3106 | 1.6% |
| Other values (630) | 94580 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 194252 | |
| o | 143043 | |
| i | 99756 | 8.5% |
| 83283 | 7.1% | |
| r | 75939 | 6.5% |
| s | 74391 | 6.4% |
| e | 62661 | 5.4% |
| u | 61195 | 5.2% |
| p | 57413 | 4.9% |
| l | 55577 | 4.8% |
| Other values (31) | 259633 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1167143 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 194252 | |
| o | 143043 | |
| i | 99756 | 8.5% |
| 83283 | 7.1% | |
| r | 75939 | 6.5% |
| s | 74391 | 6.4% |
| e | 62661 | 5.4% |
| u | 61195 | 5.2% |
| p | 57413 | 4.9% |
| l | 55577 | 4.8% |
| Other values (31) | 259633 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1167143 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 194252 | |
| o | 143043 | |
| i | 99756 | 8.5% |
| 83283 | 7.1% | |
| r | 75939 | 6.5% |
| s | 74391 | 6.4% |
| e | 62661 | 5.4% |
| u | 61195 | 5.2% |
| p | 57413 | 4.9% |
| l | 55577 | 4.8% |
| Other values (31) | 259633 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1167143 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 194252 | |
| o | 143043 | |
| i | 99756 | 8.5% |
| 83283 | 7.1% | |
| r | 75939 | 6.5% |
| s | 74391 | 6.4% |
| e | 62661 | 5.4% |
| u | 61195 | 5.2% |
| p | 57413 | 4.9% |
| l | 55577 | 4.8% |
| Other values (31) | 259633 |
seller_state
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 4883 |
| SC | 4223 |
| Other values (17) | 6093 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 231040 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 82412 | |
| MG | 9009 | 7.8% |
| PR | 8900 | 7.7% |
| RJ | 4883 | 4.2% |
| SC | 4223 | 3.7% |
| RS | 2225 | 1.9% |
| DF | 931 | 0.8% |
| BA | 697 | 0.6% |
| GO | 539 | 0.5% |
| PE | 465 | 0.4% |
| Other values (12) | 1236 | 1.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| sp | 82412 | |
| mg | 9009 | 7.8% |
| pr | 8900 | 7.7% |
| rj | 4883 | 4.2% |
| sc | 4223 | 3.7% |
| rs | 2225 | 1.9% |
| df | 931 | 0.8% |
| ba | 697 | 0.6% |
| go | 539 | 0.5% |
| pe | 465 | 0.4% |
| Other values (12) | 1236 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 91838 | |
| S | 89304 | |
| R | 16078 | 7.0% |
| M | 9625 | 4.2% |
| G | 9548 | 4.1% |
| J | 4883 | 2.1% |
| C | 4325 | 1.9% |
| A | 1117 | 0.5% |
| E | 954 | 0.4% |
| D | 931 | 0.4% |
| Other values (6) | 2437 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 231040 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 91838 | |
| S | 89304 | |
| R | 16078 | 7.0% |
| M | 9625 | 4.2% |
| G | 9548 | 4.1% |
| J | 4883 | 2.1% |
| C | 4325 | 1.9% |
| A | 1117 | 0.5% |
| E | 954 | 0.4% |
| D | 931 | 0.4% |
| Other values (6) | 2437 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 231040 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 91838 | |
| S | 89304 | |
| R | 16078 | 7.0% |
| M | 9625 | 4.2% |
| G | 9548 | 4.1% |
| J | 4883 | 2.1% |
| C | 4325 | 1.9% |
| A | 1117 | 0.5% |
| E | 954 | 0.4% |
| D | 931 | 0.4% |
| Other values (6) | 2437 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 231040 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 91838 | |
| S | 89304 | |
| R | 16078 | 7.0% |
| M | 9625 | 4.2% |
| G | 9548 | 4.1% |
| J | 4883 | 2.1% |
| C | 4325 | 1.9% |
| A | 1117 | 0.5% |
| E | 954 | 0.4% |
| D | 931 | 0.4% |
| Other values (6) | 2437 | 1.1% |
| customer_state | customer_zip_code_prefix | freight_value | order_item_id | order_status | payment_installments | payment_sequential | payment_type | payment_value | price | seller_state | seller_zip_code_prefix | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_state | 1.000 | 0.896 | 0.085 | 0.013 | 0.030 | 0.032 | 0.026 | 0.038 | 0.029 | 0.020 | 0.055 | 0.069 |
| customer_zip_code_prefix | 0.896 | 1.000 | 0.466 | -0.009 | 0.026 | 0.070 | -0.006 | 0.033 | 0.106 | 0.070 | 0.065 | 0.060 |
| freight_value | 0.085 | 0.466 | 1.000 | -0.056 | 0.018 | 0.191 | 0.018 | 0.010 | 0.424 | 0.435 | 0.048 | 0.257 |
| order_item_id | 0.013 | -0.009 | -0.056 | 1.000 | 0.005 | 0.060 | -0.007 | 0.021 | 0.256 | -0.116 | 0.000 | -0.013 |
| order_status | 0.030 | 0.026 | 0.018 | 0.005 | 1.000 | 0.007 | 0.031 | 0.006 | 0.017 | 0.016 | 0.012 | 0.013 |
| payment_installments | 0.032 | 0.070 | 0.191 | 0.060 | 0.007 | 1.000 | -0.176 | 0.272 | 0.397 | 0.318 | 0.033 | 0.066 |
| payment_sequential | 0.026 | -0.006 | 0.018 | -0.007 | 0.031 | -0.176 | 1.000 | 0.227 | -0.212 | -0.005 | 0.017 | 0.007 |
| payment_type | 0.038 | 0.033 | 0.010 | 0.021 | 0.006 | 0.272 | 0.227 | 1.000 | 0.021 | 0.015 | 0.021 | 0.018 |
| payment_value | 0.029 | 0.106 | 0.424 | 0.256 | 0.017 | 0.397 | -0.212 | 0.021 | 1.000 | 0.790 | 0.037 | 0.163 |
| price | 0.020 | 0.070 | 0.435 | -0.116 | 0.016 | 0.318 | -0.005 | 0.015 | 0.790 | 1.000 | 0.053 | 0.179 |
| seller_state | 0.055 | 0.065 | 0.048 | 0.000 | 0.012 | 0.033 | 0.017 | 0.021 | 0.037 | 0.053 | 1.000 | 0.921 |
| seller_zip_code_prefix | 0.069 | 0.060 | 0.257 | -0.013 | 0.013 | 0.066 | 0.007 | 0.018 | 0.163 | 0.179 | 0.921 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| order_id | customer_id | order_status | order_purchase_timestamp | order_item_id | product_id | seller_id | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | product_category_name | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | seller_zip_code_prefix | seller_city | seller_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 29.99 | 8.72 | 1.0 | credit_card | 1.0 | 18.12 | housewares | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 9350.0 | maua | SP |
| 1 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 29.99 | 8.72 | 3.0 | voucher | 1.0 | 2.00 | housewares | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 9350.0 | maua | SP |
| 2 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 29.99 | 8.72 | 2.0 | voucher | 1.0 | 18.59 | housewares | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 9350.0 | maua | SP |
| 3 | 128e10d95713541c87cd1a2e48201934 | a20e8105f23924cd00833fd87daa0831 | delivered | 2017-08-15 18:29:31 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 29.99 | 7.78 | 1.0 | credit_card | 3.0 | 37.77 | housewares | 3a51803cc0d012c3b5dc8b7528cb05f7 | 3366 | sao paulo | SP | 9350.0 | maua | SP |
| 4 | 0e7e841ddf8f8f2de2bad69267ecfbcf | 26c7ac168e1433912a51b924fbd34d34 | delivered | 2017-08-02 18:24:47 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 29.99 | 7.78 | 1.0 | credit_card | 1.0 | 37.77 | housewares | ef0996a1a279c26e7ecbd737be23d235 | 2290 | sao paulo | SP | 9350.0 | maua | SP |
| 5 | bfc39df4f36c3693ff3b63fcbea9e90a | 53904ddbea91e1e92b2b3f1d09a7af86 | delivered | 2017-10-23 23:26:46 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 29.99 | 14.10 | 1.0 | boleto | 1.0 | 44.09 | housewares | e781fdcc107d13d865fc7698711cc572 | 88032 | florianopolis | SC | 9350.0 | maua | SP |
| 6 | 8736140c61ea584cb4250074756d8f3b | ab8844663ae049fda8baf15fc928f47f | delivered | 2017-08-10 13:35:55 | 1.0 | b00a32a0b42fd65efb58a5822009f629 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 75.90 | 7.79 | 1.0 | credit_card | 1.0 | 83.69 | baby | 02c9e0c05a817d4562ec0e8c90f29dba | 8577 | itaquaquecetuba | SP | 9350.0 | maua | SP |
| 7 | 88407c8c6e12493ff6e845df39540112 | e902cb9d9992a69a267f69dec57aa3a3 | delivered | 2017-08-15 02:03:01 | 1.0 | b00a32a0b42fd65efb58a5822009f629 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 75.90 | 7.79 | 1.0 | credit_card | 2.0 | 83.69 | baby | 28adbfbaf0b9c5e5a0555a8c853a7534 | 13060 | campinas | SP | 9350.0 | maua | SP |
| 8 | 4f2acff0b7d2bcc4a408abe5a223d407 | d67b6cca5a87299f711a6961f579fe67 | delivered | 2017-08-01 16:31:35 | 1.0 | b00a32a0b42fd65efb58a5822009f629 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 75.90 | 14.28 | 1.0 | boleto | 1.0 | 90.18 | baby | aea90564d6f09ae11bf936f55ed49d72 | 82030 | curitiba | PR | 9350.0 | maua | SP |
| 9 | 019aaee09698daf81dcffe9d94a18b5c | e3893e579755de4feb1a4d0313c103fa | delivered | 2017-08-10 14:04:58 | 1.0 | b00a32a0b42fd65efb58a5822009f629 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 75.90 | 7.79 | 1.0 | credit_card | 2.0 | 83.69 | baby | cd6b577df45c00daa6b2767eaa947c72 | 13092 | campinas | SP | 9350.0 | maua | SP |
| order_id | customer_id | order_status | order_purchase_timestamp | order_item_id | product_id | seller_id | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | product_category_name | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | seller_zip_code_prefix | seller_city | seller_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118424 | f5f8998eee8ec7bc513dc52847d64ce0 | f4656b824844a039a87fd9c51ad3586a | canceled | 2018-03-01 11:42:23 | 1.0 | 51bd37bb8517d5bfdb1f54c11fb01d27 | f09e26011d833ddab11593c1a097a92a | 79.90 | 22.19 | 1.0 | credit_card | 2.0 | 102.09 | furniture_decor | 149164aee69ed656dedbbe68623157bc | 13469 | americana | SP | 13632.0 | pirassununga | SP |
| 118425 | 5bacbd9f42bd029c3a296501224e193e | 5a1470d43d8ad960d4199134d3df48e0 | delivered | 2018-08-10 21:14:35 | 1.0 | 710e8b076db06c8e5343a9e23f0e3d83 | 8dd386be0767c330276ea6a3f96532d3 | 44.99 | 22.25 | 1.0 | credit_card | 2.0 | 134.48 | sports_leisure | 0b39f417a3c099ff0497346258e8d752 | 39810 | carai | MG | 88490.0 | paulo lopes | SC |
| 118426 | 5bacbd9f42bd029c3a296501224e193e | 5a1470d43d8ad960d4199134d3df48e0 | delivered | 2018-08-10 21:14:35 | 2.0 | 710e8b076db06c8e5343a9e23f0e3d83 | 8dd386be0767c330276ea6a3f96532d3 | 44.99 | 22.25 | 1.0 | credit_card | 2.0 | 134.48 | sports_leisure | 0b39f417a3c099ff0497346258e8d752 | 39810 | carai | MG | 88490.0 | paulo lopes | SC |
| 118427 | 5a8a4dc28b16fb90469ad749f9535773 | c0c8b8bb055100a0cc08dcc04d847ac9 | canceled | 2018-03-13 10:58:09 | 1.0 | 33ac889bc3af4ddede9c14fc789a3743 | 666658b8da8370f30e1f89893b1de5e6 | 149.00 | 11.67 | 1.0 | boleto | 1.0 | 321.34 | garden_tools | 82ec5f749b66f1857e868b6414a67ab3 | 6765 | taboao da serra | SP | 3658.0 | sao paulo | SP |
| 118428 | 5a8a4dc28b16fb90469ad749f9535773 | c0c8b8bb055100a0cc08dcc04d847ac9 | canceled | 2018-03-13 10:58:09 | 2.0 | 33ac889bc3af4ddede9c14fc789a3743 | 666658b8da8370f30e1f89893b1de5e6 | 149.00 | 11.67 | 1.0 | boleto | 1.0 | 321.34 | garden_tools | 82ec5f749b66f1857e868b6414a67ab3 | 6765 | taboao da serra | SP | 3658.0 | sao paulo | SP |
| 118429 | 1ab38815794efa43d269d62b98dae815 | a0b67404d84a70ef420a7f99ad6b190a | delivered | 2018-07-01 10:23:10 | 1.0 | 31ec3a565e06de4bdf9d2a511b822b4d | babcc0ab201e4c60188427cae51a5b8b | 79.00 | 14.13 | 1.0 | boleto | 1.0 | 93.13 | construction_tools_lights | 2077f7ec37df79c62cc24b7b8f30e8c9 | 8528 | ferraz de vasconcelos | SP | 13660.0 | porto ferreira | SP |
| 118430 | b159d0ce7cd881052da94fa165617b05 | e0c3bc5ce0836b975d6b2a8ce7bb0e3e | canceled | 2017-03-11 19:51:36 | 1.0 | 241a1ffc9cf969b27de6e72301020268 | 8501d82f68d23148b6d78bb7c4a42037 | 19.70 | 10.96 | 1.0 | credit_card | 1.0 | 30.66 | auto | 78a159045124eb7601951b917a42034f | 89111 | gaspar | SC | 89031.0 | blumenau | SC |
| 118431 | 735dce2d574afe8eb87e80a3d6229c48 | d531d01affc2c55769f6b9ed410d8d3c | delivered | 2018-07-24 09:46:27 | 1.0 | 1d187e8e7a30417fda31e85679d96f0f | d263fa444c1504a75cbca5cc465f592a | 399.00 | 45.07 | 1.0 | debit_card | 1.0 | 444.07 | furniture_decor | 8cf3c6e1d2c8afaab2eda3fa01d4e3d2 | 60455 | fortaleza | CE | 13478.0 | americana | SP |
| 118432 | 25d2bfa43663a23586afd12f15b542e7 | 9d8c06734fde9823ace11a4b5929b5a7 | delivered | 2018-05-22 21:13:21 | 1.0 | 6e1c2008dea1929b9b6c27fa01381e90 | edf3fabebcc20f7463cc9c53da932ea8 | 219.90 | 24.12 | 1.0 | credit_card | 4.0 | 244.02 | furniture_decor | e55e436481078787e32349cee9febf5e | 39803 | teofilo otoni | MG | 8320.0 | sao paulo | SP |
| 118433 | 1565f22aa9452ff278638e87cc895678 | 56772dfbcbe7df908a284ff0d53adf7d | delivered | 2018-05-15 17:41:00 | 1.0 | 9c1e194db1d35a79d962ea610bfe0868 | f3862c2188522d89860c38a3ea8b550d | 15.50 | 12.79 | 1.0 | boleto | 1.0 | 28.29 | perfumery | 6ceea7c1088e15ab3c67980a2d9bb309 | 9687 | sao bernardo do campo | SP | 14092.0 | ribeirao preto | SP |